Attribute | Description | Physical Name | Domain | Data Type | Foreign Key Table |
StoreTenderHistory (FK)(PK) | A code which uniquely identifies the type of tender, ie cash, check, credit card, etc. | TY_TND | Code | varchar(20) | Tender(AS_TND) |
ReportingPeriodID (FK)(PK) | The unique system assigned identifier for a particular ReportingPeriod. | ID_PRD_RP | Identity | integer | StoreHistory(LE_HST_STR) |
RetailStoreID (FK)(PK) | A unique retailer assigned identifier for an RetailStore, DistributionCenter or AdministrationCenter | ID_STR_RTL | Identity | integer | StoreHistory(LE_HST_STR) |
TotalTenderMediaCount | The total number of tender media units by RETAIL STORE for each REPORTING PERIOD. | QU_MD_TND_TOT | QuantityTransactionCount | decimal(7,0) | |
TotalTenderMediaOverCount | The total monetary value of tender overages recorded by the RETAIL STORE for each REPORTING PERIOD. | QU_MD_TND_OVR_TOT | QuantityTransactionCount | decimal(7,0) | |
TotalTenderMediaShortCount | The total monetary value of tender shortages recorded by the RETAIL STORE for each REPORTING PERIOD. | QU_MD_TND_SHRT_TOT | QuantityTransactionCount | decimal(7,0) | |
TotalBeginningTenderMediaUnitCount | The opening balance of the number of tender media units recorded by the RETAIL STORE for each REPORTING PERIOD. | QU_MD_TND_BGN_TOT | QuantityTransactionCount | decimal(7,0) | |
TotalTenderLoanMediaUnitCount | The total number of tender loan media units recorded by the RETAIL STORE for each REPORTING PERIOD. | QU_MD_TND_LN_TOT | QuantityTransactionCount | decimal(7,0) | |
TenderLoanMediaTotalAmount | The total monetary value of tender loans recorded by the RETAIL STORE for each REPORTING PERIOD. | MO_MD_LON_TND_TOT | Money | decimal(16,5) | |
TotalTenderPickupMediaUnitCount | The total number of tender pickup media units by the RETAIL STORE for each REPORTING PERIOD. | QU_MD_TND_PKP_TOT | QuantityTransactionCount | decimal(7,0) | |
TenderPickupMediaTotalAmount | The total monetary value of tender pickup recorded by the RETAIL STORE for each REPORTING PERIOD. | MO_MD_TND_PKP_TOT | Money | decimal(16,5) | |
TenderDepositTotalAmount | The total monetary value of tender media deposited by the RETAIL STORE for each REPORTING PERIOD. | MO_DS_TND_TOT | Money | decimal(16,5) | |
TotalTenderDepositMediaUnitCount | The total number of tender media units deposited by the RETAIL STORE for each REPORTING PERIOD. | QU_MD_TND_DS_TOT | QuantityTransactionCount | decimal(7,0) | |
TenderOverTotalAmount | The total monetary value of tender overages recorded by the RETAIL STORE for each REPORTING PERIOD. | MO_TND_OVR_TOT | Money | decimal(16,5) | |
TenderShortTotalAmount | The total monetary value of tender shortages recorded by the RETAIL STORE for each REPORTING PERIOD. | MO_TND_SHRT_TOT | Money | decimal(16,5) | |